package com.woniuxy.stage3demo.mapper.gy;
import com.woniuxy.stage3demo.bean.caicai.UserInfoBean;
import org.apache.ibatis.annotations.*;

@Mapper
public interface OverdueUserInfoMapper {
    //通过ID查询个人信息
//    @ResultType(UserInfoBean.class)
//    @Select("select ui.id id,ui.name name,ui.gender gender,ui.national national ,ui.birthday birthday," +
//            "ui.age age,ui.authority authority,ui.validity validity," +
//            "ui.address address,ui.telphone telphone," +
//            "ui.card_id cardId,ui.address_now addressNow,ui.marry_status marryStatus" +
//            ",ui.political_status politicalStatus,ui.del_flag delFlag," +
//            "ud.card_img_1 cardImg1,ud.card_img_2 cardImg2,ud.book book,ud.work_prove workProve," +
//            "ud.marry_prove marryProve,ud.property_prove propertyProve from user_info ui,user_data ud where ui.user_data_id=ud.id and ui.id=#{id}")
    public UserInfoBean findItById(@Param("id") int id);
}
